#!/bin/sh
hive -e "create table if not exists xm02dw.receipt_info(
receipt_id string,
loan_appl_id string,
cont_id string,
loan_id string,
cust_id string,
cust_name string,
cust_type string,
cer_type string,
cer_number string,
rep_method string,
loan_type string,
int_rate double,
bal double,
currency string,
rep_num double,
arep_num double,
orep_num double,
arep_time string,
rep_time string,
frep_time string,
odue_status string,
odue_days double,
pint_rate double,
five_level_class string,
rep_status string,
ins_id double,
manager_id double,
create_time string,
update_time string,
remarks string,
etl_time string
)
row format delimited fields terminated by ',';"
echo $?